How to: Break a link.
Solution:
Open the file with the link to be broken. Select (highlight) the linked data. Delete all the text in the formula bar.
1) Open the desired worksheet with the links to be broken.
2) Click 'Yes' when asked to re-establish links.
3) Select the worksheet containing the link to be broken.
4) Select the linked data.
5) Select all the text in the formula bar.
6) Press DELETE on the keyboard to break the link.
